| Attribute | Description (where applicable) |
| CURRENCY_RATE_DATE_ID | Currency rate date |
| FROMCURRENCY | Source currency code in cross rate calculation based on X-RATES 2 |
| TOCURRENCY | Target currency code in cross rate calculation based on X-RATES 2 |
| CURRENCY_RATE_TYPE_KEY | Rate type key |
| CURRENCYRATE | The cross rate related to X-RATES 2 |
| ENDOFMONTH | Date representing end of month that the X-RATES 2 rate applies to |
| PREV_YEAR_LAST_PERIOD_RATE | X-RATES 2 rate for the last period in previous year |
| Model Name |
| General Ledger |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| X-RATES 2 | FACT_CURRENCY_RATES_PERIODXRATE | DIM_BI_TIME_BI, DIM_RPD_COMPANY_PERIOD_BI, LUP_REPORTING_PERIOD_TC, DIM_CURRENCY_CODE_BI, DIM_CURRENCY_RATE_TYPE_BI, LUP_REP_CURR_RATE_TYPE_TC | FACT_CURRENCY_RATES_PERIODXRATE | Data Mart |